#!/usr/bin/env python
#coding:utf-8

import sqlite3

conn = sqlite3.connect("adr.db")
curs = conn.cursor()

curs.execute('''
CREATE TABLE address (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name text,
  email text
  )
  ''')
query = 'INSERT INTO address(name, email)  VALUES ("wyatt","wwq@gmail.com")'

curs.execute(query)
conn.commit()

rec = curs.execute("select * from address")
print rec.fetchall()
conn.close()
